Job Description

DPR Construction is seeking a Technical Data Analyst to work closely with cross-functional teams, including Data Engineering, Software Development, Business Intelligence Analysts, and other stakeholders to gather information, understand requirements, and build complex data models, datasets and custom views for downstream business use cases. This role will be responsible for collaborating with the Business intelligence Analysts, Data Engineering and the Technical Data Analytics Lead to develop and continuously improve the strategy around creation, maintenance, optimization and enhancement of the data pipeline and data analytics consumption.
 

Job Responsibilities Summary:

• Identify and integrate new datasets, creating complex data models and QA/QC workflows for data quality assurance.
• Maintain and troubleshoot Power BI Dataflows, addressing data integrity and quality issues throughout the pipeline.
• Conduct impact analysis on reporting changes, communicating implications and mitigation plans to stakeholders.
• Develop and document dataflows, custom views, and contribute to a Data Dictionary and Self-Service platform.
• Support data literacy and best practices, including developing a Self-Service framework for Citizen Data Analysts.
• Drive continuous improvement via a technical roadmap for data models, tools, and processes.
• Collaborate with stakeholders to deliver optimized data models, understanding and aligning with business requirements.
• Use SQL to query the Data Warehouse for data analysis, dashboard creation, and identifying new data sources or integrations.
• Identify root cause of data integrity issues (report, DFL, data warehouse, source system).
• Follow, implement and enhance data security and governance guidelines.
• Providing high quality data sets to data analysts
• Understand the business questions that are being asked and predict the business questions that should be asked.
• Document a dimensional model that can answer those questions.
• Document needed source models to feed those dimensional models.
• Transform source data into dimensional data using SQL and dbt.
• Surface those dimensional models in Power BI
• Add any additional measures in Power BI required for to prepare a data set ready for self-service.

Required skills:

• Advanced SQL Skills:

• Window functions, CTE, and Subqueries must be old hat. May have need to look up exact syntax but know exactly what to look up.
• May have a developed personal code style, but willing to work with other style guides to make sure code is readable to the rest of the team.

• Advanced Data Modeling Skills

• Experience designing Star schemas.
• Recognize the difference in Star Schemas and Snowflake.
• Given an hour with the manager of an ice cream shop you could come out with a relational data model designed to run their business.
• Familiarity with Kimball Design Concepts: bridge tables, role playing dimensions, grain, degenerate dimensions
• Ability to recognize when an entity name is misleading and recommend solutions.

• Power BI

• Experience writing new measures in DAX
• Recognize the difference between dataflows and data sets.
• Understand the limitations of modeling in Power BI with regards to keys, relationships, and filter directionality.

Desired skills:

• DBT
• Understand how and why a model can be instantiated as a view, table, or kept ephemeral.
• Strong opinion on writing tests for primary keys.
• Understand how lineage is tracked
• Understand how schemas work in dbt as compared with databases.
• Git
• Understand what a branch and a pull request is.
• You might not be a git wizard, but you can get code from one branch to another.
• You have an opinion about the proper path to production.

Education

Bachelor’s degree in computer science, information technology or a related discipline.

Work Conditions

Prolonged periods of sitting and/or standing at a computer screen.

Must be able to sit or stand for long periods of time.

Must be able to lift 15 pounds at times.

Additional Information:
Occasional domestic travel, via airplane, will be required for meetings.
This is a hybrid role with most time being spent working from home. Attendance at important meetings and events at the local DPR office is required.

DPR has been nationally recognized for its strong company culture, based on a well-defined purpose “We Exist to Build Great Things,” and four core values: integrity, enjoyment, uniqueness and ever forward. A flat, title-less organization that empowers people at all levels to make decisions, DPR ranked on FORTUNE’s “100 Best Companies to Work For” list for five consecutive years. For more information, visit http://www.dpr.com.