Job summary
The SQL Server Database Developer improves the quality of data analytics to produce high-quality SQL programmingResponsible for SQL Integration (SSIS), Reporting (SSRS and Power BI), and supporting business processWorks collaboratively with staff to understand business problems and provide solutions
Job seniority: mid-to-senior level
Responsibilities
• Articulate and complete a process of discovery to build understanding about enterprise user core systems• Develop SQL Job automation schedules for data flows and maintain DW sources• Work closely with LTD BI Analysts to bridge technology capabilities with business analysis requirements• Develop and maintain technical documentation for reference, future planning, and disaster recovery• Peer checking of code and bringing in positive ideas to support business units• Creative thinking to translate business needs into required data objects• Work on IT Help Desk tickets with database, SQL, and reporting issues• Think about future data systems, capabilities, and trends• Manage confidential data and validate data• Develop and implement long-term plans for report maintenance, documentation, and data lineage• Design performance metrics related to Power BI and SSRS usage as well as report adoption
Requirements
• Bachelor Degree (or higher) or 4+ years of professional work experience• Ability to connect to SSMS, discover database objects, read views and stored procedures• Ability to write SQL queries and develop SQL views or stored procedures• Experience querying tabular models with MS Excel and SSRS• Strong knowledge of and experience with Power BI• Effective communication with IT and business teams• Experience with SSRS report development• Ability to work autonomously and be accountable for work and performance• Ability to work well with remote/hybrid co-workers and subject matter experts• Creativity in simplifying and organizing visualizations with report content
Key Skills Needed
• SQL programming• SQL Integration (SSIS)• Reporting (SSRS and Power BI)• Technical documentation• Peer code review• Data management and validation• Power BI and SSRS usage metrics• Effective communication• Remote collaboration• Data visualization