Data Integration Specialist

  • Modis,
  • Austin, TX
company banner
Modis
Architecture, Automated, Database, Data Modeling, Data Warehouse, Development, Exchange, Modeling, Oracle, SOAP, SQL, SQL Server, Testing, XML
Full Time
Work from home not available Travel not required

Job Description




Modis is seeking a Data Specialist for a contract-to-hire opportunity in Austin, TX. In this role you will be responsible for designing, building, and maintaining Enterprise Data Warehouse solutions. You will contribute to the long-term strategy and architecture for a multi-phased data warehouse effort. This role requires experience with complex ETL solutions and SSIS.

No sponsorship available at this time. You must be a US Citizen or a Permanent Resident in order to qualify.




Responsibilities:
  • Acquire, integrate, provision, and exchange of enterprise data.
  • Define the overall data warehouse architecture.
  • Develop and document technical best practices for ETL-related activities including data movement, data aggregation, data quality, and data cleansing.
  • Assess and document the structure, quality, and compliance of data sources and coordinate with staff to identify and resolve issues.
  • Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance.
  • Build reports to audit, monitor, and validate data warehouse jobs.





Qualifications:
  • Four (4) or more years of experience designing, developing, testing, and implementing complex ETL solutions.
  • Experience developing and implementing data integration and warehouse solutions in a SQL Server database environment required.

  • Experience with SQL Server, SSIS, data warehouse design, and data modeling required.
  • Knowledge of theoretical data warehouse design considerations including Inmon and/or Kimball approaches.
  • Data modeling skills are required, normalized and multidimensional.
  • Must be well-versed in T-SQL development in a multi-tier SOA environment.
  • Expertise in flat file formats, XML within SQL, and file format conversion.
  • Experience with XML and Soap/REST.
  • Experience with Oracle preferred.








If you are interested in this contract-to-hire Data Specialist job in Austin, TX then please click apply now!




Equal Opportunity Employer Minorities/Women/Veterans/Disabled


Company Information

At Modis, we have the connections and expertise to help save you time and start earning money in the right IT or engineering job for you. We use our insight, knowledge and resources to match you with top positions at leading companies. Many of our clients use our services to help fill positions quickly so they can avoid the time-consuming process of posting jobs and sifting through resumes. This can mean we can offer you access to unadvertised IT and engineering job openings and quick placement opportunities that you wouldn't otherwise know about. Get The Modis Advantage.
Dice Id : cxmodaus
Position Id : US_EN_6_914778_1032835