What are the responsibilities and job description for the BI/ETL Engineeer – Full Time | Government Agency | Orlando, FL | Competitive Salary + Benefits! position at Integris Group?
Integris Group is partnering with a local government agency in downtown Orlando, FL, to fill an immediate opening for a BI/ETL Developer. This is a full-time, permanent position offering a competitive salary, comprehensive benefits, PTO, and additional perks such as a 401K and a pension plan.
***This is a HYBRID position—no exceptions! Work onsite 3 days per week, with 2 flexible remote days (no set schedule for remote work)***
Job Overview:
- Full life cycle development: Implementation, production support, and performance tuning of Microsoft Business Intelligence environments.
- Integration: Support integration with other applications.
- Reporting and Analytics: Design and implement solutions, including table structures and data processes.
- Business improvement: Help drive improvement in key metrics, customer experience, and business results.
- Collaboration: Interact with development teams, project managers, customers, senior management, and vendors.
Essential Functions:
- Implement business intelligence and advanced analytics solutions.
- Manage design, development, release, and implementation of BI and data solutions on MS Power BI.
- Create data integration and technical solutions using SQL Server, Data Lake, Data Warehouse, and Machine Learning.
- Define and implement ETL architecture using SQL, SSIS, Data Factory, and MS ETL capabilities.
- Recommend and implement enhancements to optimize data models and processes.
- Coordinate with stakeholders to identify data requirements and reporting solutions.
- Develop solutions based on project requirements, promoting reusability.
- Write sophisticated SQL queries and DAX expressions.
- Align solutions with business strategy and objectives.
- Assist in data management, modeling, and integration activities.
Minimum Qualifications:
- Experience: Minimum of 5-years in IT, including 3 years as a ETL/BI Engineer.
- Skills: Experience with ETL on Microsoft Power BI stack, SQL Server, T-SQL, SSIS, DAX, and M-query.
Technical Requirements:
- Expertise in distributed system architecture, design, and development.
- Development of Tabular models and SQL Analysis Services (SSAS).
- Knowledge of agile Data Warehousing and Data Integration technologies.
- Strong analytical and problem-solving skills.
- Proficiency with MS Office tools (Word, Excel, PowerPoint, Outlook).
