Data Engineer I

As a Data Engineer I at Sundt, you will be responsible for the end-to-end management of data across the organization, including its design, implementation, maintenance, discovery, and governance. The role involves close collaboration with various teams, including stakeholders, business intelligence teams, report builders, and developers, to ensure that data is consumed efficiently at all levels. For success in this position, meticulous attention to detail and a commitment to delivering top-quality data are essential. The ideal candidate will possess expertise in developing data relationships, deriving meaningful insights from datasets, and mastering Power BI's advanced functionalities. Continuous learning and innovation are essential to providing the business with effective data solutions. You will be at the forefront of exploring the latest technologies and methodologies in business intelligence to keep us ahead of the curve.

In this role, career progression is structured into three steps (I, II, Senior). Step I is the entry level, ideal of individuals who meet the minimum requirements of this position, offering a chance to build on foundational skills and knowledge. Step II is for individuals that have at least three years of experience in this role and have enhanced their skills through solving complex problems. The Senior step is for those with over six years of experience that have exceptional proficiency and the ability to independently handle complex projects. These steps will provide a road map for professional growth and increased responsibilities.

Key Responsibilities:

• Build and maintain databases to store data for integrations and custom in-house developed applications
• Build metadata repository to track data flow throughout the organization to determine system of record and allow for business self-discovery
• Design, develop, and implement data pipelines to ensure high-quality data is delivered on time
• Develop and maintain data warehousing systems to be used for reporting and analysis
• Develop and maintain documentation, including data models, data pipelines, database schemas, and data quality checks
• Educate and support teams in fully leveraging data resources, ensuring high data quality and security standards across the company.
• Manage and enhance Power BI deployments, overseeing tenant and premium instances for optimal performance.
• Manage data platforms to ensure correct configuration and performance optimization
• Manage data privacy, security, compliance while enforcing data classification and protection requirements
• Masterfully utilize Power BI for creating datasets, writing DAX measures, and understanding data modeling with star schema.
• Stay up-to-date with emerging technologies and best practices

Minimum Job Requirements:

• 1+ years of Databricks, including Spark SQL experience strongly preferred
• 3+ years of SQL experience strongly preferred
• Ability to adapt to changing priorities and manage multiple tasks.
• Bachelor's Degree, 4 years relevant experience, or a combination of college education and relevant experience equivalent to 4 years
• Exceptional verbal and written communication skills
• Other preferred qualifications: Azure Data Factory, Azure DevOps, GIT repos, Python/Scala, SSIS, CI/CD pipelines, Azure LogicApps, Power BI, RedGate toolbelt, & XML
• Proficiency in Power BI, TSQL/Spark SQL, DAX, and GIT.
• Proficient use of all Microsoft Office Suite programs