What are the responsibilities and job description for the SQL Developer position at CMCI?
Job Description
SQL Developer
Location : Offsite / Remote
Why CMCI?
CMCI provides management consulting and IT services that empower enterprises to achieve their business goals in today's highly competitive market. Our goal is to seamlessly integrate into each customer's organization to fully understand their business and technology needs. This approach allows us to quickly deliver high quality solutions while achieving the highest level of customer satisfaction on time and within budget. By choosing CMCI, you are choosing a company that can deliver on business outcomes and mission needs in the most cost-effective manner and without sacrificing capability. As a part of CMCI's culture of loyalty and commitment to its employees, CMCI is committed to provide a tremendous career path by promoting employees to their highest potential.
Job Description : Qualifications and Duties
1) Establish and document the technical requirements for reporting software such as tables, views, report design, unit test plans, and test cases.
2) Assist in all phases of the reporting software development cycle including requirements gathering, analysis, design, testing, implementation, and production support.
3) 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)
4) 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.
5) Facilitate SQL design sessions and SQL code walk-throughs to ensure adherence to development standards and best practices using dbt.
6) 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.
7) Develop and maintain documentation on all database models, tables, guidelines, methods, and standards to ensure consistency and clarity.
8) Provide recommendations for further definition of development standards and application architecture based on industry best practices and emerging technologies.
9) Conduct unit testing and assist in user testing of complex SQL statements or report modifications to ensure quality and functionality meet requirements.
10) Train other staff members in development processes and standards to ensure consistency across the team.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
