Job Location: Chicago, IL
Location Note
This role can be performed remotely in a work from home arrangement within the continental United States. There is an expectation the role may need to come to a business office, typically Chicago, as many as 6 times a year, with typically two weeks’ notice for various department meetings.
Essential Functions
- Development of the conceptual, logical, and physical data models for implementing RDBMS, data marts, and data lakes on target platforms (SQL/NoSQL).
- Evaluating implemented data systems for variances, discrepancies, and efficiency.
- Create logical data models via virtualization
- Analyzing and translating business needs into long-term solution data models
- Source to target mappings and ETL design review
- Participate in maintenance and enhancements of modeling quality standards such as mappings and technical specs.
- Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
- Review modifications of existing systems for cross-compatibility.
- Update and optimize local and metadata models.
- Consult in troubleshooting and optimizing data systems.
Required Experience
- Bachelor’s degree in Math, Computer Science, Information Technology, Electrical or Computer Engineering or related field or equivalent work experience (including military) required.
- 3+ years of strong SQL experience
- Hands-on relational, dimensional, or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
- Experience in Data Modeling at an enterprise level with hands-on conceptual, logical, and physical model development
- Experience in ETL/Data warehousing Solutions (Talend, Informatica)
- Experience working with one or more enterprise data modeling tools, such as ER/Studio, Erwin, or others.
- Good understanding of Database architectures
- Hands-on experience with data warehouse, data lake, and enterprise big data platforms in multi-data center contexts required
Preferred Qualifications
- Knowledge of Hadoop ecosystem and different frameworks inside it- HDFS, YARN, MapReduce, Apache Pig, Hive, Flume, Sqoop, ZooKeeper, Oozie, Impala and Kafka
- Knowledge of ETL best practices, Cl/CD Pipeline, monitoring & alert would be a plus point
- Experience in data virtualization using Denodo
- Experience in data quality processes like data profiling, cleansing
- Experience with analytics tools like Cognos, Tableau
- Knowledge of different Operating System – UNIX, Linux, Solaris, or MS Windows
- Real-time processing Framework (Apache Spark)
- Programming Languages: Python/R/Java
- Experience working with analytics teams and solving business problems
- Strong attention to detail
- Hands on experience with communication tools like PowerPoint, Visio, JIRA etc.
#LI-JP1
Job : Information Technology
Location(s) : Illinois-CHICAGO_IL Oklahoma-TULSA_OK, Wisconsin-MADISON_WI, Washington-RICHLAND_WA, Iowa-URBANDALE_IA, Tennessee-KNOXVILLE_TN, Washington-LONGVIEW_WA, Illinois-SCHAUMBURG_IL, Missouri-COLUMBIA_MO, North Carolina-GREENVILLE_NC, Iowa-MARION_IA, Oregon-MEDFORD_OR, Virginia-ROANOKE_VA, West Virginia-MORGANTOWN_WV, North Carolina-WILMINGTON_NC, New Hampshire-BEDFORD_NH, Wisconsin-BROOKFIELD_WI, Maine-SOUTH PORTLAND_ME U.S. Cellularยฎ is an EEO employer and gives consideration to qualified applicants without regard to race/color/age/religion/sex/sexual orientation/gender identity/national origin/disability/veteran status, pregnancy or genetic information.
Submit CV To All Data Science Job Consultants Across United States For Free

Leave a Reply