Top Skills - Must Haves
sql
mdm
informatica
azure
snowflake
DescriptionPOSITION SUMMARY:Responsible for managing and supporting the corporate Master Data Management (MDM), Operational Data Stores (ODS) and Enterprise Data Warehouse (EDW) platforms. This will include collaborating with the Data Analytics Steering Committee (DASC), Technology team and product stakeholders to design, implement and maintain these enterprise platforms.Develop innovative and best practice techniques for modeling, developing, enhancing, and deploying database, reporting, and integration solutions. Lead new data integration and reporting initiatives that support organizational priorities while complying with the organization's IT and architectural standards. Establish organization wide Common Data Platform (CDP) and data integration standards. Participate in systems strategy, developing systems requirements, designing and prototyping, testing, training, defining support procedures, and implementing practical business solutions under multiple deadlines.ESSENTIAL POSITION FUNCTIONS:Design, construct, install, test and maintain highly scalable MDM, ODS, CRM and EDW platforms with state-of-the-art security, monitoring and logging practices.RDBMS (Microsoft SQL) and NoSQL design, implementation and maintenance for purposes of integration to other platforms.Bring together large, complex and sparse data sets to meet functional and non-functional business requirements.Design and implement data tools for analytics and data analyst team members to help them in building, optimizing and tuning our product.Integrate new data management technologies and software engineering tools into existing structures.Page 2 of 4Help in building high-performance algorithms, prototypes, predictive models and proof of concepts.Assist business teams to better understand, consume and appreciate the implications and benefits of MDM, ODS, CRW and EDW solutions.EDUCATION, EXPERIENCE, SKILLS AND ABILITIES:At least five (5) years of experience in architecting, designing and configuring multi-domain MDM and Enterprise Data Warehouse (EDW)At least five (5) years of relevant data management consulting or industry experience (master data, metadata, data architecture, data governance, data quality, data modeling)At least five (5) years of experience with relational SQL systems including PL/SQL, T-SQL, Job configuration/management and performance tuning.At least five (5) years of experience with designing, implementing and supporting ETL, ELT, Change Data Capture (CDC), streaming and similar data ingestion processes.At least three (3) years of experience with non RDBMS platforms.At least three (3) years of experience with modern programming languages.At least three (3) years of experience leading work streams with significant experience leading components of data engagements.Deep understanding of MDM and upstream and downstream integrationKnowledgeable in ETL design development.Experience in Pub/Sub model for data integration both on premise and cloud.Strong oral and written communication skills, including presentation skills (MS Visio, MS PowerPoint).Proficient in Microsoft applications (Word, Excel, Outlook)Bachelor’s Degree in Computer Science or related field or 5+ years equivalent professional experiencePREFERRED SKILLS:Experience in the latest components of Informatica multi-domain MDM editions including Entity 360 and ActiveVOSExperience with other data management toolsets: Informatica Powercenter, Informatica Data Quality, IICS, etc.Experience in designing and architecting integrations between Informatica MDM and other systems using standard connectors, publish-subscribe, and other mechanismsPage 3 of 4Experience with iPaaS toolsets: MuleSoft, Informatica Cloud, TIBCOExperience with Microsoft SQL versions 2008 and higher including high availability.Experience with non RDBMS platforms: HBase, Cassandra, Hadoop, MongoDB, Snowflake, etc.Experience with one or more of Python, PySpark, Java, Databricks, Node.JS, React JS, Restful APIs.Experience with one or more Cloud platforms (Azure, AWS).Experience with one or more data and reporting tools such as Informatica, SSIS, SSRS, Tableau, Power BI, Micro Strategy.Experience in a Project Management and/or Busines Analyst or similar role(s)Experience with CRM platforms: Salesforce, Microsoft DynamicsMATHEMATICAL SKILLS:Ability to add, subtract, multiply and divide in all units of measure, using whole numbers, common fractions and decimals. Ability to compute rates, ratios and percentages.PHYSICAL DEMANDS:The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is frequently required to stand; walk; sit; use hands to finger, handle or feel; reach with hands and arms, climb or balance, stoop kneel, crouch, crawl; talk or hear and taste or smell. The employee must occasionally lift and/or move up to 10 pounds. Vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.WORK ENVIRONMENT:The work environment characteristics described here are representative of those an employee encounters while performing functions of this job.The noise level in the work environment is moderately quiet. It is a non-smoking environment.The above job requirements are representative of minimum levels of knowledge, skills, and abilities. The marginal functions have not been included. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.This job description in no way implies that these are the only duties to be performed. An employee will be required to follow any other job-related instructions and duties as requested by the supervisor and/or management.Skillssql, mdm, informatica, azure, snowflake, microsoft dynamics 360, copilot, customer insightsTop Skills Detailssql,mdm,informatica,azure,snowflakeAdditional Skills & QualificationsTeam playerGood comm skillsProactive and independent worker (not someone who needs to be told what to do / micromanaged)Must live in Los Angeles, Orange County, San Bernardino County, Riverside County, San Diego CountyExperience LevelExpert LevelPay and BenefitsThe pay range for this position is $70.00 - $80.00Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)Workplace TypeThis is a fully remote position.Application DeadlineThis position will be accepting applications until Jan 13, 2025.About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.