Role: Data Engineer Advisor
Work location : Atlanta GA (onsite)
Type: Contract
Key Responsibilities:
- Designing Reporting Infrastructure:
- Create the overall architecture for data storage transformation and delivery to reporting tools including data warehouses data lakes and reporting databases.
Defining Data Models for Reporting:
- Create the logical and physical data models that support reporting requirements ensuring data is structured in a way that is efficient for analysis and reporting.
- Fact-dimensional data modeling
Developing Data Pipelines:
- Design and implement the processes (ETL or ELT) that extract transform and load data into the reporting environment ensuring data quality and accuracy.
Selecting and Implementing Reporting Tools:
- Ability to choose appropriate reporting platforms (e.g. Tableau Power BI Cognos) and configuring them to work with the underlying data infrastructure.
Ensuring Data Quality and Security:
- Responsible for implementing data quality checks and security measures to protect sensitive information within the reporting environment.
Providing Technical Leadership:
- Mentoring other team members including data engineers and analysts in the development and maintenance of the reporting infrastructure. Monitoring and Optimizing Performance of the reporting system identify bottlenecks and implement solutions to improve efficiency and scalability. Collaborating with Stakeholders like business users data scientists and other stakeholders to understand the reporting needs and to ensure the reporting infrastructure meets requirements.
Skills and Qualifications:
- Strong understanding of data warehousing and data modeling:
- 8-10 years of expertise in designing and implementing data warehouses data marts and other data storage solutions. Proficiency in SQL and other data querying languages: Ability to write complex SQL queries to extract and transform data for reporting purposes.
8-10 years experience with reporting tools and platforms:
- Familiarity with popular reporting tools like Tableau Power BI or Cognos.
8-10 years experience of data integration and ETL processes:
- Expertise in extracting transforming and loading data from various sources into the reporting environment.
8-10 years experience of data governance and security principles:
- Ability to implement data quality checks and security measures to protect sensitive information.
Excellent communication and collaboration skills:
- Ability to effectively communicate technical concepts to both technical and non-technical audiences.
Strong problem-solving and analytical skills:
- Ability to troubleshoot issues and identify areas for improvement in the reporting infrastructure.