Senior Business Intel Developer - Career Education Corporation
The Senior Business Intelligence Developer participates in the development and support for CEC’s enterprise data warehouse (EDW) systems, business intelligence (BI) tools, and operational data integration needs. The primary consumer of services is the company’s Shared Analytical & Data Services team. Responsibilities of this position include participation in the architecture, design, development, integration, deployment, and production support of ETL data warehouse / data lake systems and related ETL / data integration applications. Duties also include administration and support of business intelligence applications used by the reporting community.
Principal Duties & Responsibilities
Gathers business requirements definition, technical solution development and the implementation phases of data warehouse and reporting projects
Assists in definition of logical and physical data models for businesses
Configures and tunes ETL infrastructure to optimize the data warehousing architecture and performance
Documents business rules after reverse engineering existing SQL logic and reports
Participates in the overall development process, which includes but is not limited to architecture guidance, design, development and code reviews, and estimation and planning assistance
Creates and maintains BI/EDW ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows)
Educates internal EDW users about best practices for accessing data and building customized dashboards
Sets up, maintains and updates recurring custom reports to be delivered
Documents business needs and the technical requirements required to meet those needs with a focus on leveraging advanced functionality of BI tools
Design, develop, implement and maintain SSIS ETL packages to support data integration needs
Knowledge, Skills and Abilities, Competencies
Experience with the entire software development lifecycle including from-spec implementation and post-implementation system fixes and enhancements
Knowledge of data warehousing technologies, including ETL processes/tools, dimensional modeling, and cube design/maintenance
Knowledge of and experience in creating database query, stored procedures and views and also analyzing T-SQL queries for understanding business rules, data profiling and trouble shoot
Experience in designing and building dashboards and reports using Microsoft SSRS and Tableau data visualization tools
Strong written and verbal communication skills
Ability to think analytically, define problems and frame solutions
Ability to show initiative with minimal direction
Strong detail orientation and ability to work independently
Ability to prioritize tasks and remain in sync with development team plans
Ability to build collaborative working relationships
Demonstrated presentation skills and ability to communicate effectively both orally and written
Education and Experience: Minimum
Bachelor’s Degree in Computer Science or related field from an institution accredited by an agency recognized by the U.S. Department of Education (or international equivalent) preferred
Five (5) to 10 years experience
Microsoft BI (Advanced T-SQL, SSIS, SSRS) 2012/2016, SSAS (Tabular and multidimensional modes) and Tableau
Education and Experience: Preferred
C# .NET, MS SharePoint 2013/2016 and QlikView