search > North DFW jobs > North DFW computer/technical

Posted: Wednesday, May 10, 2017 6:35 PM

Responsibilities include the design, development, and maintenance of SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) reports, and Analysis Services (SSAS) cubes on a multi:terabyte data warehouse deployed on the Microsoft SQL Server 2005 data platform. Other responsibilities include troubleshooting data issues, performance tuning SQL queries, and ad:hoc data queries.Design and develop new Integration Services ETL packages that load data from disparate data sources into the Enterprise Integration Services Data Warehouse.Maintain and enhance existing Integration Services ETL packages currently deployed to the Enterprise Data Warehouse.Develop and test relational data base Reporting Services reports as well as Analysis Services OLAP reports based upon technical specifications.Make changes to existing Analysis Services cubes and create new cubes based upon technical specifications.Research data inquiries from business analysts and end users of the Enterprise Data Warehouse.Perform database schema deployments and data refreshes to other data warehouse environments, such as Staging, Test, and Development.Assist other team developers with SSIS package development and SQL performance tuning.Author deployment instructions and unit test cases that coincide with existing and new ETL package development and report development.Author ETL design specifications based on user/system requirements.Bachelors degree or equivalent work experience.Certification in MCITP: Database Developer, MCITP: Business Intelligence Developer, MCDBA or MCITP: Database Administrator and over 10 years experience in Information Technology.5+ years of T:SQL development.3:5 years programming Data Transformation Services (DTS) packages.ETL development using SQL Server Integration Services (SSIS).1:2 years of SQL Server Reporting Services (SSRS) reports.Understanding of relational and multidimensional data design and development techniques.Experience with data warehousing technologies, including ETL, star schemas, snowflake schemas, and cube design.Experience with reporting and analytical presentation tools and technologies, such as Panorama, Proclarity, Excel pivot table service for OLAP, Crystal.Experience loading large volumes of data into a data warehouse.Acosta Sales and Marketing is an Equal Opportunity Employer


• Location: North DFW

• Post ID: 52271518 northdfw is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2017