Tasked with working collaboratively to define and develop custom reports and dashboards that deliver information and insights to support all areas of the business. As an Analytics Engineer, you will play a crucial role in designing, developing, and maintaining our advanced analytics solutions within the Microsoft Azure ecosystem. As a member of the Data Management team, there is an expectation that you will support application development teams as a subject matter specialist in the areas of SQL and report development. The ideal candidate will have the ability to support multiple simultaneous projects, possess a passion for operational excellence and possess excellent interpersonal and soft skills.
Responsibilities: Design and develop end-to-end analytics solutions using Microsoft Azure technologies, including SQL Server Management Studio (SSMS)/ Azure Data Studio, Azure Data Factory (ADF), Databricks, and Power BI.
Collaborate with business users, data engineers, and other stakeholders to gather requirements, understand data sources, and define data models.
Extract, transform, and load (ETL) data from various sources into the Azure data platform, ensuring data quality and integrity.
Develop and maintain data pipelines and workflows using Azure Data Factory, Databricks, and other relevant tools to ensure efficient and timely data processing and availability.
Create visually compelling and interactive dashboards, reports, and data visualizations using Power BI, enabling stakeholders to gain actionable insights from the data.
Monitor and optimize the performance of Azure-based data solutions, identifying and resolving issues to ensure smooth and efficient operation.
Stay up to date with the latest trends and advancements in the Microsoft Azure ecosystem and business intelligence domain, identifying opportunities for improvement and innovation.
Assist in troubleshooting production code integration issues.
Qualifications: Bachelor's degree in Computer Science, Management Information Systems, or a related field. Certifications with strong portfolio exemplifying expertise.
Proven experience as an Analytics Engineer, Business Intelligence Developer, or similar role, with expertise in the Microsoft Azure stack.
Strong proficiency in Azure Data Factory, SSMS, Databricks, and Power BI.
Strong proficiency in SQL and experience with relational databases and data modeling concepts. Understanding Python is a plus.
3 years or more hands-on technical experience with T-SQL development.
Experience in designing and implementing ETL processes and data pipelines.
Familiarity with data warehousing principles, dimensional modeling, and data integration techniques.
Excellent analytical and problem-solving skills, with the ability to work with large and complex datasets.
Strong understanding of data visualization principles and best practices.
Ability to collaborate effectively with cross-functional teams and communicate complex technical concepts to non-technical stakeholders.
Benefits: Medical, dental, and vision insurance
401(k) with company match
Associate discounts including furniture
Company paid life and disability insurance
Paid time off
Employee Assistance Program
Wellness Programs
And more!
We do not discriminate in hiring or employment against any individual on the basis of race, color, gender, national origin, ancestry, religion, physical or mental disability, age, veteran status, sexual orientation, gender identity or expression, marital status, pregnancy, citizenship, or any other factor protected by anti-discrimination laws