Department: Information Technology Job Summary: We are seeking an experienced Data Engineer to join our dynamic team. The ideal candidate will have extensive experience in SQL querying, Power BI, ETL processes, data and query optimization, and database management. This role involves designing, developing, and maintaining business intelligence solutions to help our organization make data-driven decisions. Principal Responsibilities
- Develop and Maintain BI Solutions: Design, develop, and maintain business intelligence solutions using Power BI.
- SQL Querying: Write complex SQL queries to extract, manipulate, and analyze data from various databases. Support any modifications per end user requests and communicate updates to affected parties.
- Data and Query Optimization: Optimize data models and queries for performance and efficiency. Identify any performance bottlenecks and address effectively.
- Database Management: Manage and maintain databases, ensuring data integrity and security. Work with other shared services teams to manage space, performance, and security for optimal administration.
- Data Analysis: Analyze data to identify trends, patterns, and insights that can drive business decisions. Gain and upkeep sound knowledge of the data elements across the organization to connect disparate data.
- Reporting: Create and maintain reports, dashboards, and visualizations to present data in an accessible and actionable format. Utilize various formats to communicate insights in the most effective manner.
- Collaboration: Work closely with stakeholders to understand their data needs and provide solutions that meet their requirements.
- Documentation: Document BI solutions, processes, and best practices. Maintain a central code repository for easy access by the team. Follow standard SDLC for change management.
Requirements
- Education: Bachelor's degree in Computer Science, Information Technology, or a related field. Commensurate related experience in technology will also be considered.
- Experience: Minimum of 3 years of experience in business intelligence development.
- Technical Skills:
- Proficiency in Power BI including report creation, data modeling, and DAX.
- Strong SQL querying, ETL skills and ETL processes.
- Experience with data and query optimization techniques.
- Knowledge of database management systems (e.g., SQL Server, Oracle, MySQL).
- Experience with other BI tools (e.g., Tableau, QlikView) is a plus.
- Knowledge of data warehousing concepts, leveraging APIs, and database design.
- Familiarity with programming languages such as Python or R.
- Prior practical experience in AI and/or GenAI are desired.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent communication, accountability, and collaboration abilities.
- Attention to detail, self-motivated, and a commitment to data accuracy.
- Authorized to work in the United States on a full-time basis without Company sponsorship.
Conner Strong & Buckelew is an equal opportunity employer. It is Conner Strong & Buckelew's policy to grand equal employment opportunities to all qualified persons without regard to race, sex, religion, age, national origin, creed, marital status, color, citizenship, sexual orientation, physical or mental disability, veterans' status or any other characteristic protected by the law. Conner Strong & Buckelew provides equal opportunities in employment, promotion, wages, benefits and all other privileges, terms and conditions of employment. It is Conner Strong & Buckelew's policy to make reasonable accommodations for the disables that do not impose an undue hardship on Conner Strong & Buckelew.