Estrada Consulting, Inc ยท 2 days ago
Senior SQL Developer Business Intelligence/Data Warehouse
Wonder how qualified you are to the job?
Business IntelligenceConsulting
Insider Connection @Estrada Consulting, Inc
Responsibilities
Establish and document the technical requirements for reporting software such as tables, views, report design, unit test plans, and test cases.
Assist in all phases of the reporting software development cycle including requirements gathering, analysis, design, testing, implementation, and production support.
Debug and test PowerBI reports based on user requirements and feedback from subject matter experts to validate data. (Knowledge of PowerBI is not required but a plus)
Create and maintain complex SQL statements to generate tables and views that will be used by PowerBI developers to drive visualizations. Develop and enhance SQL-based tables and views as per user requirements.
Facilitate SQL design sessions and SQL code walk-throughs to ensure adherence to development standards and best practices using dbt.
Generate SQL tables using dbt according to established procedures and standards. Knowledge of snowflake, git, pull requests, visual studio code, and dbt is strongly recommended.
Develop and maintain documentation on all database models, tables, guidelines, methods, and standards to ensure consistency and clarity.
Provide recommendations for further definition of development standards and application architecture based on industry best practices and emerging technologies.
Conduct unit testing and assist in user testing of complex SQL statements or report modifications to ensure quality and functionality meet requirements.
Train other staff members on development processes and standards to ensure consistency across the team.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Establish and document the technical requirements for reporting software such as tables, views, report design, unit test plans, and test cases.
Assist in all phases of the reporting software development cycle including requirements gathering, analysis, design, testing, implementation, and production support.
Debug and test PowerBI reports based on user requirements and feedback from subject matter experts to validate data.
Create and maintain complex SQL statements to generate tables and views that will be used by PowerBI developers to drive visualizations. Develop and enhance SQL-based tables and views as per user requirements.
Facilitate SQL design sessions and SQL code walk-throughs to ensure adherence to development standards and best practices using dbt.
Generate SQL tables using dbt according to established procedures and standards.
Develop and maintain documentation on all database models, tables, guidelines, methods, and standards to ensure consistency and clarity.
Provide recommendations for further definition of development standards and application architecture based on industry best practices and emerging technologies.
Conduct unit testing and assist in user testing of complex SQL statements or report modifications to ensure quality and functionality meet requirements.
Train other staff members on development processes and standards to ensure consistency across the team.
Preferred
Knowledge of PowerBI is not required but a plus.
Knowledge of snowflake, git, pull requests, visual studio code, and dbt is strongly recommended.
Company
Estrada Consulting, Inc
ECI provides professional consulting services across a number of industries throughout the continental US.
H1B Sponsorship
Estrada Consulting, Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Trends of Total Sponsorships
2023 (13)
2022 (17)
2021 (18)
2020 (14)
Funding
Current Stage
Growth StageCompany data provided by crunchbase