ALIS Software LLC
Data Modeler
ALIS Software LLC, Austin, Texas, us, 78716
Must perform complex (journey-level) computer programming data technical work for the Enterprise Data Office. Work involves building systems that collect, manage, and convert raw data into usable information for data scientists, data analysts, and business analysts to interpret. This requires the ability to access data stored in a variety of database management systems (such as DB2, SQL Server, and Oracle) which will satisfy customer business requirements. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment. Communicate with internal and external customers to analyze and identify all relevant details of highly complex administrative systems that involve interchange of large volumes of data (frequently stored in disparate or geographically dispersed databases).
Design complex tables, schemas, data marts, or related data designs that provide effective and efficient access for data found among disparate and geographically dispersed systems such that reporting of entry, retrieval, and manipulation of data may be accomplished simply from a single location with complete preservation of security of the data.
Create, maintain, and manage data asset catalogs and complete inventory of organizational data.
Develop appropriate documentation and ensure established standards and best practices are applied at all stages of the development.
Minimum Requirements
II. CANDIDATE SKILLS AND QUALIFICATIONSCandidates 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.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.
#J-18808-Ljbffr
Design complex tables, schemas, data marts, or related data designs that provide effective and efficient access for data found among disparate and geographically dispersed systems such that reporting of entry, retrieval, and manipulation of data may be accomplished simply from a single location with complete preservation of security of the data.
Create, maintain, and manage data asset catalogs and complete inventory of organizational data.
Develop appropriate documentation and ensure established standards and best practices are applied at all stages of the development.
Minimum Requirements
II. CANDIDATE SKILLS AND QUALIFICATIONSCandidates 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.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.
#J-18808-Ljbffr