As a Business Intelligence Software Engineer, you will leverage your expertise in enterprise applications to design, develop, and maintain ETL processes using SSIS, and create PowerBI solutions to support business objectives. You will collaborate closely with Product Owners to understand requirements, ensuring the reliability and performance of data pipelines, while also engaging in agile team practices and staying updated on industry best practices.
Qualified candidates must be comfortable commuting to the Duluth, GA or Tallassee, AL office twice a week.
Job Details:
Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) for on-premises and hybrid environments.
Develop and optimize SSIS packages for data extraction, transformation, and loading (ETL) from various sources to target databases.
Implement error handling, logging, and auditing mechanisms to monitor and troubleshoot SSIS packages for data quality and integrity.
Design and implement data integration and orchestration workflows using Azure Data Factory (ADF) for cloud-based data solutions.
Perform performance tuning and optimization of ETL processes to meet scalability and performance requirements.
Document ETL processes, data mappings, technical specifications, and best practices for reference and future maintenance.
Develop PowerBI functionality to optimize, extend, and integrate enterprise applications, data, and reports.
Design and develop PowerBI data models, following best practices for dashboard and report creation.
Engage in prototyping, designing, and publishing PowerBI Reports.
Collaborate with Data Engineers to acquire, clean, and transform data for reporting purposes.
Conduct data analysis, profiling, and pattern recognition to troubleshoot and resolve data discrepancies.
Support QA and UAT testing activities for PowerBI solutions.
Participate in agile team ceremonies including sprint planning, daily stand-ups, backlog grooming, and retrospectives.
Stay updated on industry best practices, tools, and technologies related to ETL, data integration, and cloud-based data solutions.
Requirements:
Bachelor's degree in business, computer science, or a related field of study, or equivalent experience.
5+ years of professional experience in a relevant position.
Experience working with BI reporting tools such as PowerBI, Tableau, etc (PowerBI is preferred).
Strong ETL skills using SSIS or similar tools in a cloud, hybrid, or on-prem environment.
Experience with data-mapping, cleaning data, and documenting/following best practices.
Experience with QAD or SAP ERP preferred.
Strong interpersonal skills and strong team-building skills.
Pragmatic problem solving and decision-making skills with excellent written and verbal communications.
Relentless passion and commitment to operational excellence - delivering in scope, on time, on budget to the delight of internal customers.
The following certifications are not required but preferred, Power BI Certification, Azure Certification (Database, AI/ML), and any Cloud DB Certification.
Location:
Qualified candidates must be comfortable commuting to the Duluth, GA or Tallassee, AL office on Tuesdays and Thursdays.
About SOLTECH
SOLTECH is a leading national technology company based in Atlanta. Driven by a steadfast commitment to integrity, strong company values, and customer centricity, SOLTECH has achieved national recognition and success.
For more than 25 years, SOLTECH has been part of the thriving technology community, and has been recognized by The Atlanta Journal-Constitution as a Top Workplace, as well as one of the Best & Brightest Companies To Work For In The Nation. With a team of exceptional engineers, designers, and strategists, SOLTECH has consistently delivered cutting-edge custom software applications, technology consulting services, and IT staffing solutions that address complex business challenges.
Join us on our quest to make the world a better place by bringing to life innovative software solutions that make our lives easier, safer, healthier, and more productive.
If you are an IT professional searching for your next career opportunity, we look forward to matching your expertise and interests with a position where you can thrive. Learn more about SOLTECH careers at https://soltech.net/working-for-soltech/