Eaton's Electrical division is currently seeking a Data Integration Specialist.
The Data Integration Specialist position is responsible for the development and governance of solutions that transform raw data into valuable business insights. The specialist will be responsible for designing and implementing data integration processes using Low Code ETL (Extract, Transform, Load) tools, creating data models following industry best practices (i.e. star / galaxy schemas), ensuring automated data security through Row Level Security, and maintaining data quality through robust data cleaning methods. This position bridges the gap between complex data sources and BI analytics & insights. The ideal candidate will combine technical expertise in data integration and modeling with a strong understanding of business intelligence concepts and best practices.
Want more jobs like this?
Get jobs in Raleigh, NC delivered to your inbox every week.
The expected annual salary range for this role is $91,500 - $134,200 a year.
Please note the salary information shown above is a general guideline only. Salaries are based upon candidate skills, experience, and qualifications, as well as market and business considerations.
What you'll do:
- Design and implement data integration processes using Low Code ETL (Extract, Transform, Load) tools such as Power BI dataflows, Alteryx, and Azure Data Factory.
- Create and maintain data models (i.e. Star & Galaxy Schemas) in Power BI for use by business analysts and self-service analytics.
- Implement Row Level Security (RLS) to ensure data access is appropriately restricted based on user role and responsibilities.
- Develop and execute data cleaning procedures within the ETL process to ensure data quality and consistency.
- Optimize and maintain data pipelines for performance and scalability.
- Collaborate with business analysts and functional Subject Matter Experts to understand data requirements and deliver accessible datasets.
- Troubleshoot data integration issues and provide sustainable solutions.
- Author and Maintain documentation on data integration processes, functionality, etc.
Basic (Required) Qualifications:
- Bachelor's degree in from an accredited institution
- Minimum of three (3) years of experience in ETL (Extract, Transform, Load) operations
- Must be legally authorized to work in the United States without company sponsorship
Preferred Qualifications:
- Master's degree in business administration
- Experience with SAP, PowerBI, and advanced Microsoft skills.
- Proven track record of process improvement
Position Success Criteria:
- Proficiency in Low Code ETL tools (Power BI Dataflows, Alteryx, Data Factory, ETC)
- Strong understanding of star schema modeling and its application in Power BI
- Experience implementing Row Level Security in BI environments.
- Solid knowledge of data cleaning techniques and best practices within ETL processes.
- Familiarity with SQL and data warehousing concepts.
- Strong understanding of business operations and processes
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills.
- Ability to work collaboratively in a team environment.
- Experience with process improvement methodologies such as lean or six sigma.
#LI-LR1
The application window for this position is anticipated to close on 10/3/24.
We are committed to ensuring equal employment opportunities for all job applicants and employees. Employment decisions are based upon job-related reasons regardless of an applicant's race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, marital status, genetic information, protected veteran status, or any other status protected by law.
Eaton believes in second chance employment. Qualified applicants with arrest or conviction history will be considered regardless of their arrest or conviction history, consistent with the Los Angeles County Fair Chance Ordinance, the California Fair Chance Act and other local laws.
You do not need to disclose your conviction history or participate in a background check until a conditional job offer is made to you. After making a conditional offer and running a background check, if Eaton is concerned about conviction that is directly related to the job, you will be given the chance to explain the circumstances surrounding the conviction, provide mitigating evidence, or challenge the accuracy of the background report.
To request a disability-related reasonable accommodation to assist you in your job search, application, or interview process, please call us at 1-800-836-6345 to discuss your specific need. Only accommodation requests will be accepted by this phone number.
We know that good benefit programs are important to employees and their families. Eaton provides various Health and Welfare benefits as well as Retirement benefits, and several programs that provide for paid and unpaid time away from work. Click here for more detail: Eaton Benefits Overview. Please note that specific programs and options available to an employee may depend on eligibility factors such as geographic location, date of hire, and the applicability of collective bargaining agreements.