| Data Modeler----Austin, TX----day one onsite--- at Austin, Texas, USA |
| Email: [email protected] |
| From: Dev Soni, Tek inspirations LLC [email protected] Reply to: [email protected] Position: Data Modeler Duration: 6months contract Location: Austin, TX |Onsite workand required to live within the state of Texas Interviewswill be conducted via Microsoft Teams Job Description: Must perform complex (journey-level) computer programmingdata technical work for the Enterprise Data Office. Work involves buildingsystems that collect, manage, and covert raw data into usable information fordata scientists, data analysts, and business analysts to interpret. Thisrequires the ability to access data stored in a variety of database managementsystems (such as DB2, SQL Server, and Oracle) which will satisfy customerbusiness requirements. Works under minimal supervision, with considerable latitudefor the use of initiative and independent judgment. Communicate with internaland external customers to analyse and identify all relevant details of highlycomplex administrative systems that involve the interchange of large volumes ofdata (frequently stored in disparate or geographically dispersed databases). Design complex tables, schemas, data marts, or relateddata designs that provide effective and efficient access for data found amongdisparate and geographically dispersed systems such that reporting of entry,retrieval, and manipulation of data may be accomplished simply from a singlelocation with complete preservation of the security of the data. Create, maintain, and manage data asset catalogues andcomplete inventory of organizational data. Develop appropriate documentation and ensure establishedstandards and best practices are applied at all stages of the development. CANDIDATE SKILLS AND QUALIFICATIONS: Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. Years Required/Preferred Experience 4 Required Writing SQL and accessing data stored in databases such as SQL Server, DB2, and Oracle databases, and working experience with database fundamentals such as snowflake schema, normalized/denormalized data is required. 2 Required considerable knowledge of computer programming languages and operating systems applicable to managing and interfacing a variety of complex databases. 2 Required Experience using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating crosstab reports highlighting key summary information. 2 Required Manipulating large data sets through statistical software or other methods. 1 Required Developing front-end reporting solutions. Knowledge of Microsoft Office Suite; with considerable knowledge of Excel pivot tables, formulas, formatting, and VLOOKUPS. 1 Required Knowledge with SQL, Python, or similar language. 4 Preferred Graduated from an accredited four-year college or university with major course work in Computer Science, Statistics, Management Information Systems (MIS), Information Sciences Technology (IST), Information Technology, or a related field is preferred. 2 Preferred Designing databases. 1 Preferred Of Azure Cloud technologies. 1 Preferred Working knowledge with Databricks. Keywords: |
| [email protected] View all |
| Fri Dec 16 23:37:00 UTC 2022 |