7218 - Senior Data Engineering & Power BI Analyst
We are seeking an experienced Senior Data Warehouse & Business Intelligence Analyst to support enterprise-level data integration, analytics, reporting, and data modernization initiatives. This role will focus on designing and maintaining scalable data pipelines, supporting large-scale reporting environments, improving data quality processes, and assisting with the migration of legacy statistical reporting tools into modern analytics platforms.
The ideal candidate will have strong experience with data warehousing, ETL/ELT processes, SQL programming, Power BI, SAS, and enterprise reporting environments. This position requires excellent analytical, communication, and collaboration skills, along with the ability to work across technical and business teams.
Responsibilities:
- Analyze, design, develop, and maintain enterprise data pipelines and reporting solutions
- Build and support data warehouse and analytics integrations
- Develop and maintain data models, data dictionaries, and reporting structures
- Create ETL/ELT processes for extracting, transforming, and loading data from multiple sources
- Review and modernize legacy statistical reporting solutions and reporting environments
- Support migration efforts from legacy analytics tools to modern BI and reporting platforms
- Design and maintain Power BI dashboards and reports
- Perform data modeling and SQL development activities
- Implement and support data quality validation and control processes
- Provide technical troubleshooting and support for reporting and analytics environments
- Support onboarding, integration, and data setup activities for new environments
- Work closely with technical teams, business stakeholders, and leadership
- Create technical documentation and process specifications
- Assist with deployment, maintenance, and support of reporting and analytics solutions
- Provide training and knowledge transfer to internal teams and stakeholders
- Prepare and communicate project status updates, milestones, and deliverables
Required Qualifications:
- 5+ years of experience as a Data Specialist, Data Analyst, Business Systems Analyst, or similar role
- 5+ years of experience designing and supporting enterprise data warehouse environments
- 5+ years of experience with SQL programming and database development
- 5+ years of experience with SAS analytics and reporting tools
- 5+ years of experience developing Power BI dashboards and reports
- 5+ years of experience with ETL/ELT tools such as Talend, Informatica, Oracle Data Integrator, or similar technologies
- Strong experience with data modeling, data integration, and large-scale data processing
- Experience building and maintaining data pipelines and analytics solutions
- Strong understanding of data governance, data classifications, data access, and security practices
- Experience gathering and documenting business and functional requirements
- Experience supporting full software development lifecycle documentation and project deliverables
- Strong written and verbal communication skills with both technical and non-technical audiences
- Experience coordinating with cross-functional teams and stakeholders
- Proficiency with Microsoft Office applications including Word, Excel, Project, and Visio
Desired Qualifications:
- Experience with Snowflake administration, support, or integration
- Experience with Talend Data Fabric
- Experience with R programming language
- Experience working within government or public-sector environments
- Knowledge of cloud-based data and analytics technologies
- Experience with machine learning concepts and data APIs
- Experience supporting enterprise reporting modernization initiatives
Additional Information:
- Full-time consulting opportunity
- Long-term project assignment
- Standard business hours
- No travel required
Never miss an opportunity! Create an alert based on the job you applied for.
