At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients. Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results. Our team consists of highly motivated individuals who are passionate about learning, understanding, collaborating, and who are intellectually curious. For more information about Data Ideology visit www.dataideology.com .
Data Warehouse Architect - Full-time (FT) or Contract to Hire (CTH)
We are looking for a Data Warehouse Architect to join our growing team. Data Warehouse Architect will leverage their business and technical knowledge to develop production ready data models by integrating multiple sources of data while also working with business and technical teams to understand business strategy and objectives, gather information, and ensure business requirements are being fulfilled throughout the entire data & analytics lifecycle.
To perform in this position successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Other duties may be assigned to meet business needs.
Ability to collect and understand business requirements and translate those requirements into an actionable data warehouse plan
Knowledge of multi-dimensional and tabular design patterns and ability to identify solutions that leverage these modeling techniques
Ability to work within the SDLC framework in multiple environments and understand the complexities and dependencies of the data warehouse build within those constraints.
Ability to define and implement best practices across database design and ETL.
Ability to direct the work of others, including but not limited to directing ETL development demonstrating an understand key concepts of ETL/ELT including best practices for optimization and scheduling.
Supervisory Responsibilities: None
Education and Experience:
Bachelor’s degree in Computer Science, Information Science or related field preferred.
3+ years’ experience with Data Warehouse Architecture including dimensional modeling methodologies.
Knowledge, Skills and Abilities:
Excellent Communication skills.
Excellent Interpersonal and Customer Service skills.
Excellent Organizational skills.
Consulting environment including working at client sites. Must have transportation to various sites within the Greater Pittsburgh Area.
Hours of work and days are generally Monday through Friday. Specific business hours are dependent on client operating hours. This role allows for flexibility to work from home several days per week, dependent on client approval.
Must be able to remain in a stationary position 50% of the time.
The person in this position needs to occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc.
Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and printer.
The person in this position frequently communicates with clients and coworkers. Must be able to exchange accurate information in these situations.
Data Ideology utilizes an automated screening process. All applicants must complete this digital screening to be considered for the position. Please watch for an email directing you to take the digital screening. You will need access to both a webcam and microphone to complete the digital screening. If you do not get an invitation to the digital screening within 5 days of application submission, please contact firstname.lastname@example.org .
Data Ideology and EEO Employer
2 openings. Telecommuting is allowed.
Internal Number: (864321)
About Data Ideology LLC
At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients. Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results. Our team consists of highly competitive individuals who are passionate about learning, understanding, collaborating, and who are intellectually curious.