Spectrum Communications & Consulting, LLC.
Data Engineer
Spectrum Communications & Consulting, LLC., Chicago, Illinois, United States, 60290
What do incubators and Predictive Sales AI (PSAI) have in common? Well, they’re great for growth, and even better for stability. As an innovative software development and digital marketing company pioneering the field of artificial intelligence, we can offer our newest Data Engineer the best of both words – a high energy, forward-thinking start-up culture, inside of a well-established, profitable, and stable structure. If you’re interested in getting your hands dirty and inciting change into a larger organization with a vision to change the world uses data today, then please read on.
ResponsibilitiesDesign, build and maintain both new and existing data infrastructures using tools including (but not limited to) Microsoft SQL Server, Azure Tables, Azure Blobs, and Azure CosmosDetermine the right database system for a provided data setDrafting database/table schemasProperly index tables when applicable to ensure query performanceCreate data pipelines for transforming new datasets into consistent, reliable data systems that are usable across multiple platformsIdentify optimizations and improvements in existing data pipelinesCreate solutions for data validation to ensure data integrity, accuracy, and consistencyEnsure data is readily available for analysis and development usageShifting existing big data pipelinesCome up with data validation solutions for both initial data imports as well as resultsAudit the automation process to make sure there are no gaps, redundancies, or faults in the data pipeline that would cause damage to data integrityPlanning query efficient data store schemas with respect to the data requirements of our internal data warehouseCommunicate with data scientists and other software engineers to build proper data pipelines for efficient and cost-effective queryingDevelop, construct, test, and maintain architectures with the help and feedback of software engineersDetermine and implement proper data schemas that align with PSAI's and Spectrum’s client’s business objectivesRecommend and implement ways to optimize data reliability, efficiency, and qualityConsult and suggest different technologies for our team to test and utilize togetherIncorporate the business objectives of key stakeholders in the architecture of our data warehouseResearch new and interesting data acquisition opportunities
Some Characteristics That Define YouSelf-Starter. Building a data warehouse is no simple task. You will need to come in with a self-starter attitude to not only make this data engineering role what you want it to be, but make a stellar and efficient data warehouse while you’re at it.Analytical. In order to solve problems and build innovative new digital marketing campaigns, it is essential that you know how to take an idea and analyze it from all of its angles.Developer. In the ever-changing world of artificial intelligence, it’s not enough just to build models. You bring to the table an eye for data patterns along with a knack for relational database engineering.Patient. As a data engineer, you know that you work with extremely large data sets on a daily basis. As such, we are looking for someone who is not only meticulous but patient enough to sit and sift through that data in a thorough way.Creative. Beyond just analyzing data sets, you are an explorer and a puzzle solver. Pulling insights out of your data and understanding how those insights can better shape our tools is something that you live to do.Student. More so than most industries, the field of data science is always changing and evolving. As such, you are always looking to learn new things and gain new skills.
Required Skills And ExperienceA bachelor’s degree/pursuing a bachelor’s degree in computer science, mathematics, statistics, information systems, or a related fieldExperience with statistical modeling1-3 years working experience with Python and/or SAS languages1-3 years working experience with SQL databases and database querying languages1-3 years working experience with C#/.NETFamiliarity with Microsoft AzureFamiliarity with Graph database structuresExperience with both RDBMS and TDMSExperience with data mining and data cleaningExperience with data visualization and reporting techniquesWritten and verbal expression
BenefitsComprehensive medical & dental insuranceRetirement planning & company matchingGenerous PTO, including sick days & holidaysCoworking space access for remote and hybrid work optionsYear-round gym membershipsPaid continuing educationHybrid work from Home, meetings a few times a month to strategize new projects
About UsOur mission at PSAI has always been the same—growth. Whether that be helping our customers find quality new business, developing and challenging our team members, or evolving our products and services with advancements in technology and best practices, we have always been looking towards bettering ourselves for the future. Now as we continue to grow, we find ourselves as not only the nation’s leading digital marketing and software provider for the home services industry, but an innovator and ground-shaker for the world of artificial intelligence as well. From marketing automation software powered by AI, to top-notch digital marketing services via those same AI insights, we love what we do and are excited to continue to innovate for the future together.
#J-18808-Ljbffr
ResponsibilitiesDesign, build and maintain both new and existing data infrastructures using tools including (but not limited to) Microsoft SQL Server, Azure Tables, Azure Blobs, and Azure CosmosDetermine the right database system for a provided data setDrafting database/table schemasProperly index tables when applicable to ensure query performanceCreate data pipelines for transforming new datasets into consistent, reliable data systems that are usable across multiple platformsIdentify optimizations and improvements in existing data pipelinesCreate solutions for data validation to ensure data integrity, accuracy, and consistencyEnsure data is readily available for analysis and development usageShifting existing big data pipelinesCome up with data validation solutions for both initial data imports as well as resultsAudit the automation process to make sure there are no gaps, redundancies, or faults in the data pipeline that would cause damage to data integrityPlanning query efficient data store schemas with respect to the data requirements of our internal data warehouseCommunicate with data scientists and other software engineers to build proper data pipelines for efficient and cost-effective queryingDevelop, construct, test, and maintain architectures with the help and feedback of software engineersDetermine and implement proper data schemas that align with PSAI's and Spectrum’s client’s business objectivesRecommend and implement ways to optimize data reliability, efficiency, and qualityConsult and suggest different technologies for our team to test and utilize togetherIncorporate the business objectives of key stakeholders in the architecture of our data warehouseResearch new and interesting data acquisition opportunities
Some Characteristics That Define YouSelf-Starter. Building a data warehouse is no simple task. You will need to come in with a self-starter attitude to not only make this data engineering role what you want it to be, but make a stellar and efficient data warehouse while you’re at it.Analytical. In order to solve problems and build innovative new digital marketing campaigns, it is essential that you know how to take an idea and analyze it from all of its angles.Developer. In the ever-changing world of artificial intelligence, it’s not enough just to build models. You bring to the table an eye for data patterns along with a knack for relational database engineering.Patient. As a data engineer, you know that you work with extremely large data sets on a daily basis. As such, we are looking for someone who is not only meticulous but patient enough to sit and sift through that data in a thorough way.Creative. Beyond just analyzing data sets, you are an explorer and a puzzle solver. Pulling insights out of your data and understanding how those insights can better shape our tools is something that you live to do.Student. More so than most industries, the field of data science is always changing and evolving. As such, you are always looking to learn new things and gain new skills.
Required Skills And ExperienceA bachelor’s degree/pursuing a bachelor’s degree in computer science, mathematics, statistics, information systems, or a related fieldExperience with statistical modeling1-3 years working experience with Python and/or SAS languages1-3 years working experience with SQL databases and database querying languages1-3 years working experience with C#/.NETFamiliarity with Microsoft AzureFamiliarity with Graph database structuresExperience with both RDBMS and TDMSExperience with data mining and data cleaningExperience with data visualization and reporting techniquesWritten and verbal expression
BenefitsComprehensive medical & dental insuranceRetirement planning & company matchingGenerous PTO, including sick days & holidaysCoworking space access for remote and hybrid work optionsYear-round gym membershipsPaid continuing educationHybrid work from Home, meetings a few times a month to strategize new projects
About UsOur mission at PSAI has always been the same—growth. Whether that be helping our customers find quality new business, developing and challenging our team members, or evolving our products and services with advancements in technology and best practices, we have always been looking towards bettering ourselves for the future. Now as we continue to grow, we find ourselves as not only the nation’s leading digital marketing and software provider for the home services industry, but an innovator and ground-shaker for the world of artificial intelligence as well. From marketing automation software powered by AI, to top-notch digital marketing services via those same AI insights, we love what we do and are excited to continue to innovate for the future together.
#J-18808-Ljbffr