IEA Management Services, Inc.
Data Intelligence Developer
IEA Management Services, Inc., Indianapolis, Indiana, us, 46262
SummaryFor us, "family" doesn't describe our size or capabilities, rather it's a way of doing business.
It means we put people first. From our committed and dynamic safety culture, to the way we treat our employees and clients, to how we interact with project stakeholders on a daily basis, our focus on people allows us to achieve our goal of doing a good job, and doing it with integrity.
We offer a comprehensive benefits package to include:
Competitive CompensationHealth InsuranceVision & DentalHealth Savings AccountFlexible Spending AccountsShort- and Long-Term DisabilityLife Insurance401(k)Position ResponsibilitiesThis position is to oversee the development of Power BI dashboards, Crystal Reports, write the necessary SQL Queries/procedures, update the data warehouse as necessary utilizing SSIS and build new start schemas.
Work with end users to understand business case and reporting requirements to address data challenges/issues
Build the necessary SQL Queries/Views/Tables/Procedures as required for report or dashboard
Build Power Query Script and/or DAX to get the required data
Develop relational database star schema data model
Build the table, matrix, graph, etc. and compare results to core data to confirm accuracy
Conduct necessary meetings and work with the end user to test and tweak the dashboard as necessary
Follow proper procedures for publishing new reports or dashboard
Publish and maintain the various dashboards, for all the different areas of the company (Project Controls, Safety, Procurement, Equipment Management, Accounting, etc.)
EducationHigh School Diploma
Position RequirementsMust be authorized to work in the United States now and in the future
BS in Computer Science preferred
At least 5 years of SQL coding experience
At least 3 years of developing Power BI dashboards
At least 3 years of developing SAP Crystal reports
Experience with a data warehouse
At least 3 years experience with building complex star schemas in Power BI
Experience with using APIs to connect Power BI to external sources
Vista by Viewpoint experience is a plus
Experience in R or Python is a plus (predictive analytics)
Experience with SSRS is a plus
TrainingOn the job, Compliance and Safety
Equal Opportunity StatementIEA, and our family of companies, is an Equal Opportunity / Affirmative Action employer. We consider all qualified applicants for all positions without regard to race, color, religion, gender, national origin, age, disability or any other legally protected status. We also comply with all applicable laws governing employment practices and do not discriminate on the basis of any unlawful criteria.
It means we put people first. From our committed and dynamic safety culture, to the way we treat our employees and clients, to how we interact with project stakeholders on a daily basis, our focus on people allows us to achieve our goal of doing a good job, and doing it with integrity.
We offer a comprehensive benefits package to include:
Competitive CompensationHealth InsuranceVision & DentalHealth Savings AccountFlexible Spending AccountsShort- and Long-Term DisabilityLife Insurance401(k)Position ResponsibilitiesThis position is to oversee the development of Power BI dashboards, Crystal Reports, write the necessary SQL Queries/procedures, update the data warehouse as necessary utilizing SSIS and build new start schemas.
Work with end users to understand business case and reporting requirements to address data challenges/issues
Build the necessary SQL Queries/Views/Tables/Procedures as required for report or dashboard
Build Power Query Script and/or DAX to get the required data
Develop relational database star schema data model
Build the table, matrix, graph, etc. and compare results to core data to confirm accuracy
Conduct necessary meetings and work with the end user to test and tweak the dashboard as necessary
Follow proper procedures for publishing new reports or dashboard
Publish and maintain the various dashboards, for all the different areas of the company (Project Controls, Safety, Procurement, Equipment Management, Accounting, etc.)
EducationHigh School Diploma
Position RequirementsMust be authorized to work in the United States now and in the future
BS in Computer Science preferred
At least 5 years of SQL coding experience
At least 3 years of developing Power BI dashboards
At least 3 years of developing SAP Crystal reports
Experience with a data warehouse
At least 3 years experience with building complex star schemas in Power BI
Experience with using APIs to connect Power BI to external sources
Vista by Viewpoint experience is a plus
Experience in R or Python is a plus (predictive analytics)
Experience with SSRS is a plus
TrainingOn the job, Compliance and Safety
Equal Opportunity StatementIEA, and our family of companies, is an Equal Opportunity / Affirmative Action employer. We consider all qualified applicants for all positions without regard to race, color, religion, gender, national origin, age, disability or any other legally protected status. We also comply with all applicable laws governing employment practices and do not discriminate on the basis of any unlawful criteria.